UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SMlTuhxIOYawZfV1bFYDIAhbvTtHR0vWoBeO8T51hsQ='
WHERE
key_id = '16bd6de91952207234f1ae7bb24c4d1722f22afb69814672f513500a4989cfe7'
AND (
token = 'SMlTuhxIOYawZfV1bFYDIAhbvTtHR0vWoBeO8T51hsQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)