UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kP4lAvTUDUDXrw3REfyRvSOIexx0RQk4o/6ruzeun64='
WHERE
key_id = '42071d2e2506580a17d7c1cd550348b20060ca02f193f8517dd81e243bf18d87'
AND (
token = 'kP4lAvTUDUDXrw3REfyRvSOIexx0RQk4o/6ruzeun64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)