UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHSSPWWimmCEzJ1QZ3CM2iYeJ4w7Vdxu7dk5TNcjqHE='
WHERE
key_id = 'e995a8c2b7041b0624237dd92af6daac1a9697e85b53ec5112919b36e48a78c5'
AND (
token = 'pHSSPWWimmCEzJ1QZ3CM2iYeJ4w7Vdxu7dk5TNcjqHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)