UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cr0Sps1xX5ZXapAuoQWbeoZKtbXdwEic0cZjtYXdFek='
WHERE
key_id = '55e4d7651324c0682ce001ac8930402990bd8011e1500964da0f1dfa6b30f30b'
AND (
token = 'cr0Sps1xX5ZXapAuoQWbeoZKtbXdwEic0cZjtYXdFek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)