UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DSXMPNqGaJLN8J+RRPmBJ5dljF9WNG0UicYkUQEQT8w='
WHERE
key_id = 'ef9b3c63f3778035335e15782fc76ed22548c268bfa6af49f55d216524de958d'
AND (
token = 'DSXMPNqGaJLN8J+RRPmBJ5dljF9WNG0UicYkUQEQT8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)