UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9v6brQeRqwdq9PRn9tet68jfcJXsyVxhQc1My/JKMpY='
WHERE
key_id = 'bb8af2b062d210452550a860f356402bdbf45a0eb5f023d2291ef9d4dacd821e'
AND (
token = '9v6brQeRqwdq9PRn9tet68jfcJXsyVxhQc1My/JKMpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)