UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1aqnR9SWgjtD5BwqYob9ErWIs4XQtYyFBAkYXKU47zQ='
WHERE
key_id = '4c36e1a27c0105791999ea013cd31581bbf6ccf026a1784a1e3dc9af641cd8d9'
AND (
token = '1aqnR9SWgjtD5BwqYob9ErWIs4XQtYyFBAkYXKU47zQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)