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