UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GHcIjRHFWn15bR4QZxt1wK2MctC/5yJFJAhAelK2uMU='
WHERE
key_id = 'bfa416238dffb7e5a0ff62f29b69eda6310aa1019de7daf6de5f00c9cd03259c'
AND (
token = 'GHcIjRHFWn15bR4QZxt1wK2MctC/5yJFJAhAelK2uMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)