UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCpqPREDVJDh5i9pWvXndDBG+g2u8ajF7bBvUNw+xfE='
WHERE
key_id = 'c67a05a9b79749e8f149d8e0a2ce761b25050059abf428feb061b26c06a215c5'
AND (
token = 'QCpqPREDVJDh5i9pWvXndDBG+g2u8ajF7bBvUNw+xfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)