UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bLF8OJybf7VsmaCWJYy1/kSeurQoROxgvg1waIPJ+oE='
WHERE
key_id = 'b9d417d1e3c2e3e963acd35fd77dd2cad171eb148effb2aac6bf389e735d8d8e'
AND (
token = 'bLF8OJybf7VsmaCWJYy1/kSeurQoROxgvg1waIPJ+oE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)