UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3J1mgqU01rLzKf+EBAkn/CaPHvJUr8Wh8AGSH/jtMJA='
WHERE
key_id = 'b6d1479cc46ac127b6042b298a60af5d1d674cce704b528c63840bb98a89cfb4'
AND (
token = '3J1mgqU01rLzKf+EBAkn/CaPHvJUr8Wh8AGSH/jtMJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)