UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qpZZd7tOwF3D8GWrBKthJR6fIr2LvzTBTJI48vTSu+E='
WHERE
key_id = 'c416ffcf6f547d7250e6ce863f4ef3b1ba3293bc50af22813adec47a87a1e50b'
AND (
token = 'qpZZd7tOwF3D8GWrBKthJR6fIr2LvzTBTJI48vTSu+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)