UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pdrKEs23pqoLl/fzfbz9yF9+SvClPvLPcsBRJczTpe4='
WHERE
key_id = 'e32dafbef1bf1387c41a563af61d0daf0845256b10777c4d1415e94eef277cee'
AND (
token = 'pdrKEs23pqoLl/fzfbz9yF9+SvClPvLPcsBRJczTpe4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)