UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lr6bEPKE2o+idMrXpat15oD9ENcVNkCwvQRLjvp1Cts='
WHERE
key_id = 'd589e3368775c87b958245dec9b95efab9e5cfd392731e598bc3f271efa80279'
AND (
token = 'lr6bEPKE2o+idMrXpat15oD9ENcVNkCwvQRLjvp1Cts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)