UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y9RDCEE4rkhjCm7DIxDfr4gmC+T3Vk4szhVOzZ3lZ0o='
WHERE
key_id = '1bbd7c222eef98cb4c7c43e8c108383f619024b38fa1fe02b7cde456513c7305'
AND (
token = 'Y9RDCEE4rkhjCm7DIxDfr4gmC+T3Vk4szhVOzZ3lZ0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)