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