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