UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LrrXiUC9ZDrHZCGV1Zdd0/6GdzwilO5L7YgXXB22hYE='
WHERE
key_id = 'd328f0530108e6e1d11a864e72ae7e21f84934bba526129d95ee07857f74e303'
AND (
token = 'LrrXiUC9ZDrHZCGV1Zdd0/6GdzwilO5L7YgXXB22hYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)