UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jG48p30i3MolzTwti8ZYC5+J5IAmAgqI/nDbtpra4DA='
WHERE
key_id = 'b8e36f940d56d824ddf90430818a29de0ea5bc570122d09d16cff7938aff8970'
AND (
token = 'jG48p30i3MolzTwti8ZYC5+J5IAmAgqI/nDbtpra4DA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)