UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P9R3A4ZUOJJUnvrBmP3uC3rMxtGH4MlWuKAl/z0hcl8='
WHERE
key_id = '8c016e99f9ba6ab7c72e214a0ffa7e35c0624b4efcb769a76847dfe43c7c0289'
AND (
token = 'P9R3A4ZUOJJUnvrBmP3uC3rMxtGH4MlWuKAl/z0hcl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)