UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VJVjsCx+4f1eCvgCbmyULfBjuSrXKILJGX+keN80zJw='
WHERE
key_id = 'ae07e921002146247b9ca92d74818500a33a8cb01b6f0f7ffb8279c8a2080467'
AND (
token = 'VJVjsCx+4f1eCvgCbmyULfBjuSrXKILJGX+keN80zJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)