UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5BcVDk6DTJRh0owVHhytIvIZfTDaLxQGgNsDioULnfM='
WHERE
key_id = '3e2621fc131a963a0b5119473ef580473f7961241f7d7116c9f8039234ecec30'
AND (
token = '5BcVDk6DTJRh0owVHhytIvIZfTDaLxQGgNsDioULnfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)