UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9MDN86aH0WmkM5s3cVFJh7KPIiUKcwQlAWs7HIL1Vrc='
WHERE
key_id = 'a9faf1777867219b2cfa9de88ec185942d0157172afd766f79caf88ee476861a'
AND (
token = '9MDN86aH0WmkM5s3cVFJh7KPIiUKcwQlAWs7HIL1Vrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)