UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W13R4kvw5KyU43fLbj7Eh4d7RfWbeUYMbA6e4Tij2eE='
WHERE
key_id = '7a5eb1f492679c9d6e952fc06898c44d7a648496e3419cd6822e0a669c20b87f'
AND (
token = 'W13R4kvw5KyU43fLbj7Eh4d7RfWbeUYMbA6e4Tij2eE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)