UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OpxHEQmHA/w808HSGslQtGIr6Ch/haJv/X4gAsGbzsw='
WHERE
key_id = 'daefae8a3fa4b279f1a5b4223289a739a6929beab18c9be94b2de9a82ea955e1'
AND (
token = 'OpxHEQmHA/w808HSGslQtGIr6Ch/haJv/X4gAsGbzsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)