UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MYTw7a4KCGwMOug2gX8JKSUDqkZ9c/0mzUYfYG0HYFE='
WHERE
key_id = 'a4d271e4a597150b571896b9044d284aa328333da4d3e7e5f165deaf6a065dce'
AND (
token = 'MYTw7a4KCGwMOug2gX8JKSUDqkZ9c/0mzUYfYG0HYFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)