UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVHgp4C7pCsboigXFlur2sWUE1cmIgY1TFctVMSZKa4='
WHERE
key_id = '0ae11aaab2122e97a8f55ac0a774e83662aae5f055591614bb977a5e5f90c888'
AND (
token = 'ZVHgp4C7pCsboigXFlur2sWUE1cmIgY1TFctVMSZKa4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)